Formula rather than result shown in cell due to formula not begin with =.

Cause:


This problem occurs because the formula does not begin with an equal sign.

Solution:


Add an equal sign (=) at the beginning of the formula.